I'm very sorry you're going through such an upsetting situation. It is your home and your life he is upsetting. I suggest setting boundaries: that he cannot drink or be drunk in your home. There is nothing you can say to an active alcoholic that will make him/her stop drinking but your life is valuable and you have a right to have the life you want for yourself.
God bless...