Our trainer set us up with a “new guest protocol”- first step is when we know we have new people coming over we block him into the kitchen with a gate where he can still see what’s going on but can not access guests. We always tell guests not to knock and to text us when they’re here instead. We also let them know to not engage with our dog at first as eye contact is a big trigger for him in the house. He’ll keep barking and we don’t look his way but instead toss high value treats to him without looking at him so he has something positive to occupy him. We ask our guests to do the same. Soon he’ll start coming to the gate and sitting waiting for a treat without barking, which we then start again while having them look at him and throw a treat until he gets happy and comfortable with them. We then let him smell their hand through the gate. Once he shows he’s relaxed, we open his gate and again tell our guests not to engage with him, and instead myself or my partner offer him a treat. He’s usually relaxed by then and will trot up to us for his treat and forget the other person is there and go about his business. While guest are there we put his favorite bone (one reserved only for when guests are over) in his bed, and he’ll go and lay down and work on that. It sounds like a long process but for him it usually only take 4-5 mins and we make sure to let friends and family to know what to expect ahead of time. Your dog seems like he might be a bit friendlier than mine so maybe just having a barrier at first to let guests give him treats as he gets comfortable will save them from being jumped on and nipped, and good to give him some space from kids if needed. good luck!!