Terrifying footage captures massive waterspout at the beach