Nanny Cay is is basically in the boon docks when it comes to restaurants and bars.
In my opinion you would be better off getting a captain only bare boat and take your children sailing through the islands, the rates would be comparable to a hotel and the young ones would enjoy it.
The other option would be to go to St John USVI where there’s endless beautiful beaches and restaurants with Friendly service and positive attitudes.