You'll only get wet if the water is high and there's a lot of spray in the air. Even then you can avoid it but it's part of the 'fun' of being there especially for the young ones.
Carrying a lightweight waterproof jacket would be a sensible idea anyway as the area does get quite a lot of rain.