In my Shul, I buy all the whisky in advance, and I’m in charge of giving it out. If I see that someone looks like he may have had “one too many” I will not give them any more, and, of course, no minors are permitted to have anything.
In fact, even 21 somethings can’t get anything out of me without their parent’s permission.
Everyone who wants just gets a bit “happier”, but it is a way of controlling the situation, without going stone dry.
I stop giving out drinks as soon as Leining and Aliyos start, so that by the time Mussaf comes around, everyone is fine.
In my five years of doing this, no one has ever gotten out of hand, and we’ve had no incidents of anyone getting sick or hurt, C”V.
I receive emails every year thanking me for the responsible way our Shul handles the drinking situation.
The Gabboim stop anyone else who brings in bottles.
It’s a system that really works, and our Shul’s Simchas Torah is wonderful.