Waterspouts were spotted spiralling off the Mediterranean coast as flash floods and severe storms battered a popular Brit holiday spot