Jamaica 45 or Aruba 51 are both a short walk over the bridge to the main pool and food court. The walk is about 5 minutes. Those two villages are very close to a bus stop too.
We have been upgraded before to a water view room in Jamaica but I think there was a lot of foliage so you really didn't see much of the lake.