Another possible solution would be: do not drink yourself. Make it normal that not everyone drinks alcohol at these events. Don't make a fuss about it, just don't drink.
Even if you normally normally drink at social events. It is after all still work and you are still responsible for your team.