"Rooms close to the water" all depends on your interpretation of the word "close". All of the tide pool area in between the hedges of the grassy area just past the pools all the way to the beach itself is off limits. There is one path through the middle of that area to the beach. Going off of the path anywhere in the area in and around the hotel is prohibited and will not go over well with the locals. It's probably a 2 minute walk from the closest rooms to the beach.
As far as the room category map is concerned I'm pretty sure that all of the rooms in the Ka'ahumanu Tower (right side tower in the map) are now MVC rooms. I know that the one that they showed to me during the tour is in there.
Also as shown in the map, the top 3 floors of the Kamehameha Tower on the left are considered "Ocean Front" and I think that each room would take up 2 of the squares shown. There are very few "Ocean Front" rooms and they couldn't be farther from the one set of elevators.