I only know of Mt Princeton RV Park, Snowy Peaks and the KOA there are surely others in the area though. Never stayed at any of them except the KOA. Views depend on the specific site at KOA the other two should have good/decent views of the Collegiate Peaks since they are on the east side of the highway but again may depend on site if someone is in front of you etc. The Arkansas River runs behind Snowy and Princeton however no idea if you have access to it from the campground and it is running very high at the moment due to the late snow melt this year. Koa has no streams unless it rains hard like it did our last stay it just dumped rain for about an hour several inches, hail the whole deal. It did some major damage but as soon as it stopped they had the loader out clearing the roadway and filling in the new 2' deep water ways. A couple trailers in storage were sunk up to the frames where the water washed out the ground underneath their jacks. However outside of a few not being able to get out due to the washouts until the loader got them fixed all the campsites themselves seemed ok and no one suffered any water damage at least from the washouts and there was total accessibility within 90 minutes they really did get the loader working quickly so people could come and go.
The KOA sits quite a bit further back away from hwy 285 so no real traffic noise. The other two sit right on 24 since I havent stayed there cant say for sure but have to believe there would be more traffic noise.