My guesses, not that I've had to tackle this sort of problem before.
First don't buy alcohol for keeping in the house; so you have to go socialise to drink at all.
Then go with friends who can apply peer pressure to remind him of his aim and encourage him to stop at one or two and no on to something non-alcoholic. There are non-alcoholic beers, one can';t expet them to be as good as the real thing but that's little enough to put up with to achieve the aim. Or get a taste for juice or soda.
Aside from that get his wife to accompany him to the tavern with her new rolling pin, ready for action.