I understand your plight
I have a dog that can drive me to drink sometimes too
Obedience training with this type of dog ... high energy is a must
if you do it yourself or go to a professional is up to you
The other thing is you need to get him to use up all that extra energy
If you have a yard
Supervised runs ... play fetch
High energy dogs like Yorkies need to exend that energy
and Cats
My dog Zach LIVES to search for and make lives of cats miserable
There are some ferral cats that live in my neighborhood
If he sees one He'll scream and yelp as if all hell broke loose
You'd think he was being beaten
If he wasn't on a leash I'd worry about what he would do to them
or what they would do to him