Disney Dream has the first water coaster called the Aquaduck. Yes it does go over the edge of the ship, and yes it has 2 water jets, but really it isn't a scary ride. You spend all this money to ride this fancy boat, you really should give it a try. It's also alot of fun.
Video...