I agree with the suggestion that you find an AA meeting today. AA meetings are full of people whose drinking led them to situations even more, ahem, awkward than yours, and they recovered and have self-respect and the respect of others once again.
You have no idea what will happen at this meeting, but it may well be that you will be strongly warned about future incidents. You are also likely to be referred to your employer's Employee Assistance Program, in which case I suggest you gratefully accept. The best thing you can do now is to own your problem and start taking the necessary steps to address it.