Waterspout sends beachgoers scrambling