SledinFam - Although Marquette would be great, if you are looking for close (relative to going to the UP), that's not it. That's a LONG drive from the Twin Cities. Houghton would be good (or near there, say South Range and the Wildlife Refuge) as that is a college town and there is lots to do there, and places to go. You won't find anything else like it closer, until you stay in Hurley/Ironwood on the Mich/Wisc. border. Snow is good there too. And you have the option of just going into Wisconsin or Michigan. But, if you want some REALLY good snow, my suggestion is the Wildlife Refuge cabins. They are big supporters here, and are close enough to Houghton for an easy drive to town for shopping, movie, whatever. You'll be right on the trail in the heart of the big snow!
There are lot's of other good places to stay that support this site, and they all would treat you well. Just from reading your post, I just think this one would fit your needs best. Hopefully they have space for you!