Having booze around doesn't bother me... when my alcoholism is "on", I will find any booze in the house and drink it no matter what the consequences. But when it's "off", it becomes inert and doesn't pull me. In my history of relapsing, the switch has never been flipped by the presence of alcohol, I'm more at risk from emotional factors. So in my case I feel fairly safe with it around. But it's also never been a consideration because I live with roommates; I'm not in a situation where it would make sense for me to make a request like that.
I do agree with the others that in your case, since you're the one providing your adult child with a place to live, it would certainly be reasonable to ask for a dry home.