It's always a challenge to take a trip with your dog if it involves an overnight stay. The good news is more hotels now accommodate dogs, and you can even find private vacation rentals that allow pets as well.
AllTheRooms.com, the largest and most complete accommodation search engine, offers several helpful "pet etiquette tips" when you travel with your dog. Recommendations include doing research beforehand on dog-friendly accommodations, monitoring behavior, cleaning up after your pet, and more. Read the article here: https://www.alltherooms.com/w/2017/10/guests-pets-travel-pet-etiquette-tips/
In addition, if you or anyone you know is planning a trip to the Westminster Dog Show, held in New York City in February 2018, AllTheRooms offers a handy listing of dog-friendly accommodations, including hotels and private rentals, near the show: www.alltherooms.com/