Cross Creek Campground (in Colorado) has two creeks that pass through it (which originate from one creek that forks just above site #4, where a small cascading waterfall can be found), and has great sunset views over the nearby reservoir.
Cross Creek is small and quiet campground, has lots of shade, is walking distance from lake and stream fishing as well as two trails (Cross Creek Trail #812, and Trail #864 to the largest Douglas Fir in the Rio Grande National Forest).
You can learn more (and see more photos) on Cross Creek's page.