I have stayed at YC concierge water view many times. I prefer the rooms with numbers that start with 52__ (5217 is my favorite). These are further down the hall than the rooms YCFAN mentioned, but I don't find the walk to be too terrible. These rooms look out over the pool. The view of the pool, the lagoon, the Boardwalk, parts of Epcot, etc. is awesome. The high fireworks parts of Illuminations can be seen from these rooms.