Most universities and colleges these days offer ‘substance free housing’ so check out that option. My S and his now-wife met while living in a dorm that was sub-free. S liked that he could party elsewhere and, when he’d had enough of the festivities, come back to a clean, quiet dorm - so much so that he chose that option for all 4 years. So it’s not the sub-free residents don’t party - but they keep it under control and are respectful of others who don’t want the party in their rooms. And they end up meeting other people whose idea of a good time doesn’t revolve around partying.
Sub-free dorms are often the newest and nicest ones on campus because the housing office knows that people won’t be throwing up in the stairway at 3am. It includes a wide range of people, so don’t worry about silly stereotypes that the only people living there are recovering substance abusers checked in by the parents or orthodox religious types for whom alcohol is off limits. Almost everyone in S’s dorm was there because they had a similarly low tolerance for living among people who still hadn’t learned to drink in moderation or smoke somewhere else.