http://www.dogfriendly.com/
A lot of places are actually dog friendly.
Even "high end" hotels. Some require a deposit, some require that the dog is NOT left untended in the room that way there is less risk of damage and so housekeeping can access. The NYLO is dog friendly. Not sure what others in Dallas are, never needed one.
I've taken my dog overseas multiple times. He is 75 lb mutt puppy. Spoiled doggo.
While I wouldn't personally keep a dog at my incall (I have a personal house for him to stay at) I have never been a touring girl and needed to take him with me.
If I did need to, I would be upfront, and considerate like you have.
Crate, separate room, advanced notice.
I can't stop my dog from barking or whining when he wants something. *sigh* A bad habit I didn't stop soon enough and can't break now.