At least three people have been killed as a storm system spawned tornadoes in the Gulf Coast states of the US.