My favorite moderate splash pad that we've experienced is the POFQ splash pad.
Deluxe, I'd have to go with the Poly. The riviera one was nice, but we were baking in the sun and the Poly didn't seem as terrible based on the angle of the sun in the evenings when we would go there.
At that age, I wouldn't take it into account though, they'll be happy with whatever is there.