If you learn nothing else, learn that.
It is perfectly possible to go to a kegger and drink water all night and still have a good time meeting interesting people and talking to them about interesting things.
Find those interesting people. Keep looking at different parties until you do.
I still keep in close contact with friends I met at University, and would not trade that experience for the world.
Do whatever you want, and don't let others stop you. If you enjoy going to parties - go. Someone deciding to get out of control and funnel a pitcher of beer doesn't mean you can't be standing 20 feet away having a great conversation with interesting people.
The same goes with joining a club of any sort. I mildly wish I joined the entrepreneurship club - but didn't since the majority of people there were all talk and no action.
That suggests another point - you will likely regret NOT doing things more than doing things. It is the time to experiment and potentially make some small mistakes.