How To Kennel Cockapoo When I Have Company And Have Him Not Be So Loud?

My dog is a pleaser and is kennel trained. BUT he NEEDS to be apart of everything! If we run out to the back yard, he barks up a storm. If I run my daughter to school, he will poop in the house. I can’t leave for 2 mintues without kenneling him. We take him alot of places, and he loves being apart. BUT I can’t even run the garbages outside without him barking SO loud all the neighobors can hear it and he spazs out. If I have company over that doesnt’ like dogs, I kennel him and he barks So loud the whole time I have comapny and we can’t even talk. He NEEDS to be apart of everything. I spray him with water when I have company if he is kenneled. Nothing. I get a cup of water and dump it on him, nothing. I have him totally soaked (water DOES work when he is not so wound up). Than I feel mean because I am QUIET and have totally soaked my dog in his kennel,how do I get him to just BE QUIET and be good when kenneled and I am still in the house (he is quiet if we leave)?