It will just be a matter of time before he falls in love with the new pup. Yorkies have such amazing little personalities and he won't be able to resist loving her.
I too am a neat freak - Yorkies are great with not shedding so that's a huge bonus.
I think you'll be pleasantly surprised.