I don't know if it's the best, but you can rent wave runners right at Great Bay Beach right at the pier. I didn't rent them but I have read on the boards that it is around $35-45 for 30 min. Go further down the beach for better deals.
This is on St. Martin.