Welcome to Yorkie Talk. I'm sorry for your loss of your little guy, and for the health challenges you face.
As you know, puppies need lots of training. Smaller pups like Yorkies need ample potty access. Finding one willing to sleep 8 hours is a roll of the dice, especially a puppy. Some will, but many won't. Maybe with a lot of exercise and late evening activity, but many adult Yorkies usually need to potty fairly early in the morning.
Would you consider using a piddle pad in an xpen setup? That is probably your best bet, although I will say, my pad trained boys still want poops taken care of right away, which often means I have to get out of bed around 5 - 6 am.
Barking: de-barking surgically can lead to collapsed trachea, which the breed is already at risk for. Many de-barked dogs learn how to bark anyway, they just sound squeaky and sad.
Barking collars, the kind that shock, are not 100% effective and arguably can cause damage to the heart and nervous system.
The citronella collars that spray when the dog barks are also not completely effective. I remember one member here wrote that her little rascal learned how to make the collar spray a doggy sibling.
The best deterrent for barking is training and lots of exercise.
Finding the right breeder who breeds for good disposition is your first hurdle. An older dog who has been well-trained might be best. Everything is a gamble though, and I agree with AngelFae that your husband has to be on board, committed to helping train.