From remote and untouchable to popular and touristy, these are some gorgeous bodies of water