ok, so i was wondering how do you get a promotion whithin the foundation. […] i mean how does someone get on the 05 council.
O5 councilmembers kind of vary between interpretations. On one side you've got the Ecce Perago / Annon tales, on another you've got more grimdark or coldly professional interpretations. There is no canon for O5 promotions!
also if someone had been exposed to some scp for too long, how does that effect his chanses of getting a higher post.
Depends on the nature of the SCP object and the nature of the exposure. Generally, they'd probably be kept in quarantine if it's really bad, but if the worst case scenario doesn't involve the person being a huge liability, there might be room for them to be promoted. I feel like it really depends on the specific scenario; others might argue that any excessive exposure to an anomaly is a security liability preventing the individual affected from being considered for promotion.
also, everything related to retirment would be appreciated
You might want to type in "retirement" into the search bar at the top right. Just asking someone "give me everything on the site related to retirement" seems kind of lazy on the part of the OP. That said… there is no canon on retirement. There may be different cases depending on the nature of the job held by the individual, or possibly it's just amnestics and a nice senior living house, or a Foundation-owned retirement facility, or it's the same as regular non-Foundation retirement and people can live with their next of kin if they wanna.
also, what about families?
You might want to make your question a bit more specific here. What about families? Everyone has family, whether or not they care about/interact with/bother to contact regularly/etc. is different between each Foundation employee.