Has anyone traveled with a pet, and stayed in a pet friendly hotel before?

We're thinking about going to my husband's family, and they don't allow dogs in the house. (they live on farms, and all their dogs are all outside/farm dogs) *Side note* our dog was actually one of these farm dogs, but now he's a city, house-living dog

Well I don't want our dog to sleep/stay outside all night (think 0-20 degrees, Minnesota winter) So I'm thinking about just booking a hotel nearby! Let our dog run and play outside during the day, but then stay with us at the hotel at night. Has anyone had experience at a pet friendly hotel??