Rowdy 'party pirates' are taking over the waters off NYC's City Island and driving locals nuts: 'Fun on steroids'