Chatfield in Denver Metro isn't too far, same with Cherry Creek. You'd have to check with the Denver metro to find out fees, docking points and such. I think Chatfield is run by the Army Corp of Engineers (used to be anyway) and I am not sure about Cherry Creek.
For truly spectacular scenery though, Blue Mesa Res. in
Curecanti National Recreation Area (U.S. National Park Service) (outside of Gunnison and is a 3 hour drive). You'd want to check with the parks service to see what watercraft restrictions they may have.
Another place (about 1 1/2 hours) is Dillon Res. in Summit County. I would check with the town of Dillon or Frisco to see what resources they have.
There's John Martin Res. outside of La Junta (or Lamar) but keep in mind that area is very flat and not much better than Pueblo.
Colorado Springs is not well known for any water sports except dodging potholes filled with snow melt or rain water.
