I think you are missing the point of using a crate and that is for several reasons. First and most importantly most people use crate a a means to housebreak their pets. So tying your puppy or any dog up to contain them will not work, they will still be able to poop and pee all over where ever you tie them up at. You place them into the crate and the theory is that they will not use their house as a toilet. So you need to restrict their area to a small confined space taking them out repeatedly until they are fully housebroken. You also use a crate to limit their ability to freely roam when they are puppies and can get into all types of dangerous things just like a child. You would not leave a small child at home alone and you should not leave a puppy unattended because either know danger. Dogs have been know to chew through their leashes or even chew electric cord or get into things around the house that could harm them. So when you leave the house for school, work or whatever you will need a safe place to put your puppy while he is out of your site
ie a crate or Xpen. Just like a child as they prove themselves they are allowed more responsibility and access to freedom while you are gone.
Furthermore, Yorkies are one of the hardest dogs to house train so you need to use diligence or you will end up with a dog that will poop and pee at will all over your house which I am sure will not be appreciated. A crate will really allow you the upper hand in house training a Yorkie.
By no means an I trying to be rude but a puppy is a HUGE responsibility and it sounds like you have never been a pet owner before. Maybe you should start much smaller and work your way up to a puppy.
If you think that an old fashion plastic or metal crate is not pretty enough here is a link to something much more elaborate
Custom Dog Crates from Shabby Pet - Extra Large Crate