Tourists run in terror as waterspout tears through beach resort