There are 4 tiers of seating, ranging from $115-175. The cheapest seats (poolside) are actually the ones closest to the stage, and are definitely the best bang for the buck. You are so close that you can feel the heat from the flame projectors, and see the emotions on the faces of the cast members. You may get splashed by water (we did) during the show, but will not be utterly soaked. You will still be far back enough that you can pretty much see everything going on (I didn't even really have to crane my neck all that much).
I wasn't entirely sure what to expect when the show started, and initially did not have very high expectations (shows like this one are not really my thing). When the show concluded, I ended up leaving my seat quite impressed, and feeling like the $$$ I spent was well worth the amazing ~90-minute performance. The show is a marvelous mix of acrobatics, dance, and acting (all to an expertly selected-soundtrack/score). The lights and colors were mesmerizing. I would rank attending this show as an essential part of any first timer's trip to Las Vegas.