At least eight people have been killed and thousands displaced in the South African city of Cape Town after the worst storm in three decades unleashed heavy rains and high winds.