Mosquitoes can be brutal, but can be managed, too. You'll want to invest in some anti-biter measures for your backyard BBQ during the summer.
Horsetooth Reservoir is great for rowing, stand-up boarding, and boating. Just don't be that guy who screams his boat by a a group on boards or kayaks. Sadly, there are plenty of them.
It is a small town, so be prepared for that. It has a lot of similarities to College Station (even CSU was Colorado A&M back in the day. I wear my Colorado A&M Aggies shirt to gamee).
Housing inventory is in short supply and you don't get as much for you money as you do in Texas. The Group is one of the bigger real estate agencies out here and they can help.
The job market is pretty tight up here as well. I wouldn't recommend coming here without something already lined up.
Tons of good hiking, mountain biking, road biking, running, and fishing spots. The Poudre River Valley is amazing. The closest skiing is either Eldora or Snowy Range (WY) - both at about 1:45 away. Definitely means that you want to plan your trips to anything off of I-70. I would recommend going up Thursday and coming back Saturday night if you can. Avoid holiday weekends.
At last count I think there were 15 breweries in a 20 mile radius. Lots of good beer. There are dispensaries too, if weed is your thing. In that regard, you will notice those working in the service industry tend to take a lot longer to do their jobs. Just remember it is a college town were pot is legal.
Hope to see you at some Aggie game watching events next fall. Cheers.