We've used Cordelia's Pet Resort a few times. They're fantastic.
I've heard good things about Yapper Valley, but they're a fair bit fancier and dearer than Cordelia's. The pickup service would be good though, as packing our two greyhounds in the back of the car and driving out to Cordelia's is a hassle sometimes.