Hi there and thank you for your question.
Hmmm sounds like quite the situation but with some training i am sure he will be a great and well behaved pup.
The issue does seem to be based around over excitement, you are probably the one person who he wants to get attention from the most.
The aim of the training is to not reward him when he is being over-excited. At the moment through no fault of your own your pup is getting rewarded when he is overexcited.
From now on you have to completely ignore him when he is being overexcited. This means no eye contact, no body language, no talking to him and no comforting him. The second he calms down give him attention but keep it low key so not to over excite him. If he again gets overexcited ignore him and start again.
The process will take a long time but with consistency and time i am sure you will have success. Don't be tempted to reprimand him as this may force him to become a nervous urinator.
Good luck and please let me know how things go
Todd