During the course of my professional career I’ve come across very successful professionals that come from colleges not as prestigious, and conversely I’ve seen other professionals from prestigious schools with mild accomplishments. Statistically having a degree from a prestigious college may help you make a faster way to the interview, and even to land the job, and will of course provide the opportunity to establish important long-term relationships, but the fact of the matter is that the rest depends on you.
You should also consider working part time to partially cover the grad school tuition so that you don’t incur in big debt, after all working while studying will add experience to your resume, but also don’t feel so bad if you need to incur in debt to attend the school of your dreams, as getting the right job after graduating will certainly help you quickly pay back.
Depending upon who you speak with will determine the answer to this question. Personally, I've read plenty of articles which state it is not worth going into large amounts of debt just so you can put a high profile name on your resume. On the other hand, some believe the network you will develop while at school is worth every penny. I currently attend Rutgers University in Newark, NJ as a part-time MBA student. I am very mindful of how much debt I am accumulating and even if I had the opportunity to attend a Harvard, Stanford, Wharton, etc. I think I world still go with the public institution to save money.
Also, at the end of the day it's less about the name on the resume and more about what you have done since graduating.