It is hard to know what to do with pets when you are traveling, and I think that each case is different; so there is no good answer for everything in this case.
If we were going on a trip, I would ask my neighbor lady to take care of Tootsie, our younger dog, since she is friendly with just about everyone.Then we would take Chipper along. He is 10 years old, and doen't do well with strangers and doesn't like children at all becasue he is pretty delicate.
If we went somewhere on a bus or train, then it would not be possible to take any kind of a pet along; so in that case; I would have to have someone come over to the house and make sure they had food and water while we were gone.
When I used to sell insurance and traveled a lot; I often took my big Gladiator Doberman along with me. I had a Mazda pickup with a camper on the back, and could make him a nice comfy bed back there, and opened the little slider window that went from the back to the front, so he could put his head through and look out the front.
He totally loved going along with me, and I would just make sure to rent a motel room where they allowed pets, too.