Here are three of the shots that I uploaded quickly without any processing. I was on the second level - premium viewing and used a 16mm f/2.8 lens for all shots. You are close to the water so I feel a wide angle lens is best to capture the full range of the show. I bumped up the ISO to 3200 and shot away. For the most part I'd say you need a short exposure for the water screens - but you could possibly get some interesting shots of the fountains with a longer exposure.
Now - as I mentioned I was on the second tier - above the area that is the "wet zone". This was also the middle section. It was a pretty calm night as well but part way thru the show a breeze began. Mist from the fountains hit us. Oh - and the one errant very high fountain that I looked at and though - "hmmm - that seems headed right for us". And then 5 seconds later - drenched!! Those fountains are putting out LOTS of water!! For the most part I covered my camera but it did get wet during the show if that's a concern for you.
The whole platform is standing only and is not sloped so it will require a very high tripod if you don't get right in the front of your standing section. I held the camera over my head for every shot.