I can help you out with the housing issue. I work in the industry and there are plenty of rentals in Old Town.
Check out www.campusrentercenter.com
they are both good old town property managers with all the good houses.
There should be pictures. If not shoot me a personal message and I can hook you up some ideas of a place I have that might work out.
The poudre rocks in the summer. You can go to class and boat go back to class, then back to the river, then hit the pubs. Bring both boats for sure. The season doesn't look like it will last to long, so playboating the narrows early and late is always a blast.