sounds like a year old whose mother kicked him out. He is looking for his own turf and without food, he will be gone in the morning. He was probably looking for a safe place to sleep during the day. Even at a year old, corgi could get seriously hurt. Depending on the size and temperament of the hound dog, it's up in air. Play it safe and have your neighbor keep their dogs inside. Raccoons often carry whole host of nasty parasites where the dogs or even humans can get it. You should probably hose off your balcony. Let it dry completely afterwards.

So how bad can a raccoon get? I've heard enough stories... My Norwegian neighbor (deceased) recounted a story where adult male raccoon had dragged a full grown German Shepherd into a pond and drowned the dog. It's probably country folklore...