These cities are good places to live if your best friend has four legs and gives sloppy kisses.