Yes, some doggy day care centers offer overnight stays. But if you want, you can check in your dog to a pet hotel as they have facilities for long-haul slumber. Put up a task on Airtasker and get a quote for doggy day care prices for overnight stays.