Actually, many studies of college health and drinking show that only about half of college students drink regularly. It may vary a lot by campus - drinking culture may be bigger in some places than others - but at most colleges, significant swaths of the student body don’t drink and have wild alcohol-fueled parties. It’s a common stereotype about college students but is not universally true.
There are a myriad of different ways to make friends on campus besides going Greek, and there are lots of different things young people can do to have fun besides party. Don’t worry about this - just be yourself and get involved, and try to talk to people!