The Twin Cities' most infamous party spot has undergone a makeover—but try telling that to the regulars