First, welcome

!
Second, read a lot in this thread:
http://www.yorkietalk.com/forums/gen...ent-guide.html
I'd want to know more about the Dam/Sire's health status...their knees etcetera before buying this puppy.
As far as pee pads...I use the pee pad method and I wish I never, ever would've gone down that road as I think it really confuses the dogs. I'd recommend training for outside potty only if I were you.
I agree that if you are going to get a puppy, a good time to get one is when you have some time off to spend caring for the little kiddo.
As far as the cats, you will be able to train the puppy to treat the cats appropriately, over time.