Like to stay near the water? What about living on a shore of a river or a lake? Here are some of the best options.