I'll second Unicorn's advice, George! Best of luck with everything, but I agree that the fact you are posting about it proves that you are wise enough to be planning/preparing ahead for this visit.
I have a similar kind of friend - Gareth. We were kind of the 'terrible twins' as teenagers. It was all innocent fun, but my parents would always blame him - and his parents would always blame me - for all the drunken scrapes we got into. And so it continued into our 20s and beyond...
I don't see him too often nowadays, but we keep in regular contact. I was trying to imagine how it would be if he visited me. I can't say for certain how I'd handle it. But it reminded me that another of our old "gang", Tim, got drunk twice when we were teenagers, didn't like it (and, maybe more importantly, didn't trust the way it made him feel), and has been teetotal ever since.
Gareth and I have stayed with Tim countless times over the years. Sometimes we're both there together, and sometimes not. Either way, Gareth and I would always get drunk, and Tim would always stay sober. I guess the thing is, both we
and Tim always had a great time - Tim is confident in his sobriety, he doesn't feel he's missing out on anything by not getting drunk; and we never felt awkward about his sobriety - he's a smashing bloke and his company is what mattered, not what he was drinking.
What I'm cack-handedly trying to say is that
you're a smashing bloke - and I'm sure your friend thinks that, or he wouldn't be visiting and he wouldn't understand the problems you've had. So, personally, I think you should have confidence in your sobriety and try and be like Tim. Your friend can be like Gareth, if he likes; but, regardless, you'll both have a great time - because, ultimately, it's each other's company you'll enjoy. It would be an odd kind of friendship if it relied on you both getting blotto every time you saw one another!
Think I'm rambling again, so I'll shut up!
You know you have all our support, whatever you decide, George
Mark
"I think it is the excitement only a free man can feel, a free man at the start of a long journey whose conclusion is uncertain. I hope I can make it across the border ... I hope the Pacific is as blue as it has been in my dreams. I hope."