
When I needed to get to the West country from 'up East', over a weekend, to check out some accommodation for an impending move, I had a local couple with decent refs. come in to sit mine. I was aware that although they said they'd be sleeping in my home, they were doing other 'sitting' too but frankly I felt that was okay for just 3 days max and I had to go. Yes mine were ok when I got home, but clearly they'd not confined them to the kitchen when they left them as asked, and there was a large (urine?) mark on the living room carpet. I was not amused.
Over how many years, we actually didn't take holidays, mainly because the cost of boarding them would be more than our holiday cost

We did to away for 9 days at one point, leaving our lot for a kind neighbour to look after. The trouble with that was everytime we moved to a different mobile area, the phone rang and I immediately panicked thinking there was a significant problem. We were in Europe at the time!
I think you may be looking at either not going away, or taking your dog with you!!