Cold front brings heavy rain, flooding in Northern Cape