Joshia's Bay on Tortola usually has good surf action and also has a surfing school and rentals.

I have seen people standing on the SUP and using the dinghy to pull them around kind of like water skiing. Being able to do that would depend on your dinghy. If it's the standard issue 9hp model, it may not work so well.