> You also have the problem that people get suspicious of people hanging around not drinking alcohol.

Once you're out of college I think this is mostly in your imagination. Nobody will judge you for drinking water or diet soda and you similarly shouldn't judge someone for enjoying a beer at a social event.