Waterspouts and hail as storm sweeps Mid North Coast from the south