I personally think, you either CHOOSE to make friends or you do.
Now, I have a 1 friends out of several who doesn't drink due to personal reasons. Now, she still comes out with us, and likes to have a good time and that's great.
Now if you can do this then you'll make friends. If you ostracize yourself by saying "sorry, you drink so I can't be friends with you" then you will only have yourself to blame to be honest. Like if you don't like drinking then you shouldn't really have a problem with other people drinking? If they try and force/peer-pressure you into drinking alcohol then find other people.
However, I personally think you will make friends with people who drink or you won't have any friends at all. I know some unis have "non-drinking" halls of residence. But obvs, that depends on the uni itself.
I don't think you should let alcoholism influence the way you will make friends at uni. Freshers will be intoxicated with drunk people and tbh, that's exactly how I met some of my friends through alcohol.
I'm trying to see it through your lense. But my ultimate advise is try and find a mutual respect for each other. But you can't neglect their needs to drink cause that won't be fair. You have to find a common ground with one another.