We too upgraded from standard to CY in order to use the pin code last trip. We were in room 4141. (easy to remember even 2 years later!) We had an incredible view of the pool, geyser, water parade, and could see some fireworks at night. I didn't ask for anything in particular... I was happy to be able to use the code and still save money! But if you want to be sure to see the main pool, lake, etc... I believe you should request "inner courtyard," because some CY views are of the villas.
Have a great trip. WL is amazing!