I went to CSU and was able to manage about 4 days of skiing a week. I stacked my courses Tuesday and Thursday and would stay all weekend. If there's a will, there's a way!
Fort Collins is a great town to live in and a great place to get an education.... but you have to work extra hard to get a lot of snow days in. If you are looking for a school more conducive to skiing, check out University of Utah, Northern Michigan University, Westminster College (Utah), Western State (near Crested Butte, CO), Denver University, University of Vermont, Reno University (Nevada), CU Denver, CU Boulder, or Regis University.
I am in grad school at Regis University right now, and driving one hour to the slopes instead of 2 is quite a treat.
It's all about what you're looking for. CSU was amazing... sweet people, cool classes, and fun night life. You're going to learn and have fun wherever you go. Good luck!