Damaging and destructive winds will tear through much of South Australia after severe weather sweeps across the state.