Be honest. "It's not going to happen. How about a friendly cuddle and a good night's sleep?"
Or arrange separate beds and let him/her know ahead of time and WHY. A friend will understand.
How about oral sex? Just a thought, not an offer.