Waves crashed over coastal barriers and travelled into a seaside car park in a storm which has put an end to the biggest drought in a century in Cape Town.