Biggest 'sea tornado' in a decade terrifies locals as it heads towards busy tourist hotspot