Wild Wadi Park is situated pretty much right in front of the Burj-Al-Arab. It is a water amusement park. Wild Wadi gets several visitors everyday, so you might not want to visit it when it is a public holiday, or on weekends, because the queue just keeps going on and on.
Wild Wadi Park has some really wild rides. It is most famous for the Jumeirah Sceirah. The Jumeirah Sceirah is a water slide about 33 metres tall and is the largest water slide outside the U.S. It is not for the faint-hearted. Trust me. You feel nearly weightless while on it. It really really freaks you out. So do not go for it unless you are really confident about it.

If you are going with your family, with little kids, try the Juha Dhow. The Juha dhow is basically like a small lagoon, which has been designed mainly for children. Another awesome ride is the flowrider. It is a surfing area, an artificial one.
If you are not in the mood for exhilarating rides, then you should probably head to the Breaker's Bay. The Breaker's Bay is HUGE. The largest wave pool that I have ever seen. Really awesome!

Another awesome experience is the flood river. This is the first ride that I went to as soon as I entered the park. A friend had told me about this ride. You basically sit on a circular rubber tube and you are swept by gushing river rapids through a pre-determined course. The waves are really WILD! The freaking waves sometimes reach upto around 2 metres! It is simply too good.

Wild Wadi park is regarded as over-priced by most. I agree. The rides are all terrific fun, but the price is a little too much. It is around 70 $! If you have a heavy wallet, then I personally suggest that you don't mis out on the Wild Wadi for anything in the world!