I think "In-house hotel guest" means a guest who has rented a room in the hotel as opposed to an "outside guest" who comes for such hotel services as bars, restaurants, etc.
I'd suggest: "Etes-vous client de l'hôtel?" keeping in mind that "client" here does not really make the distinction between in-house and outside guest.