The mini concrete bridge/dam over the water next Falls Road (after the falls), off the road between Hampden and Maryland Ave.

Not the overlook at the top of the hill; it's through some greenery and right overtop the water.

Also this thread idea is based.