I've been avoiding drinking it so far due to the hints from the girls about it being bad for you. Does drinking the z-cola affect the story at all or does it just give you more hitpoints?

As far as I can tell, it has no negative effects.

if you drink two z-cola but you don't get a blowjob scene with Caroline, you need get hurt two more times to get 1HP or you don't get a scene