Honestly, you told him he couldn't stay with you. I'd stick with that. He hasn't found a place to stay, so you could make a reservation at a hotel or airbnb for him.
My mother was an active alcoholic and she wasn't welcome to stay with me. I don't allow alcohol in my home. And aside from her drinking, the expected verbal abuse was something I would no longer tolerate.
I have very strong feelings about this and that may not be the same in your case. But, listen to your soul and do the right thing for yourself.