Really good advice so far, I just wanted to add that a school in the middle of nowhere might be actually more conducive to partying. Because the kids have nowhere to go or nothing to do at night, many will probably stay on campus drinking and partying. Take PennState. Talk about being in the middle of nowhere. The university is basically the town (aptly named State College). And yet, they don't call it Happy Valley for nothing.
(Of course, there are probably exceptions to this rule that I haven't heard of.)