To my understanding, you can go kayaking at the @Hilton Dubai Jumeirah Resort. It's a popular spot for families, and if you also want to do other in water activities other than kayaking they also have parasailing, jet-skiing and fishing trips.
1