Columbia is going to be sort of dull on NYE, because most students go home for Christmas break and don't come back until after NYE.
There is a rugby club at the University.
You can contact the University for help in finding a place to stay.
http://offcampus.missouri.edu/started.html