I have relatives that take their dogs with them even on a 200 mile (one way) trip to visit relatives for a few hours. Some people are very attached to their pets.
Heck I've taken my birds to a few family parties just because it didn't seem like a party without them! At least when I first got them I did that. For an overnight stay, I either bring them or get a bird sitter.