Keller-
Not sure how old you are, but if you are old enough you are going to find a lot of similarities between State College/Penn State and Auburn/Auburn University- especially the Auburn of the 90's to early 2000's before the whole dang area exploded. People are about equally friendly in both places as well (excluding the young drunks). Both campuses are beautiful, but Beaver Stadium is not "surrounded" by as much as Jordan Hare, so you will see so much more tailgating. In fact, it will look like one large tailgate.
Since I no longer live in the area, and do not make it back as often as I would like, I will leave the advice to others. Suffice it to say I've been to War Eagle Supper Club (RIP) and Sky Bar more since any nightlife in SC. lol
Lastly, forgive my Nittany Lion brethren and friends beforehand for their love affair with the Crimson Tide. PS and UA are tied together from history, and (until Saban) mirrored each other fairly well, so it is understandable. But, they have only met the good ones. They have not had to live among the others...... the WalMart (or Dollar General) variety.
I think you will enjoy your time! I am headed north too... look for me, I will be the one in white.