If he wouldn't get himself accommodation and expects to say at your place after being advised, I'd definitely lay down the no alcohol rule. I know you've worked it out, just needed to say. Totally selfish.
Sounds like hell to me too, if he's drinking. Keep the faith.