Help!!!

well im a bit confused my cousin has counter strike source, i really want to play online with him. Does a steam account give you the games? Like if i buy a steam account with css can i download it and play css then? If not how can i buy css with paypal. Someone help please!!