Don't wander into Casey's Splash n' Soak Station by mistake! It's pretty obvious, but I'v seen someone do it (looking at their phone of course)!
Splash is the only real "wet" ride at MK. Pirates you might, thanks to the newer boats, but I've never experienced anything extreme there. Keep an eye on that camel (he spits at people just walking by the ride too). Interestingly enough, the Little Mermaid ride involves no water at all!