A heavy storm in Ceuta has left the Spanish enclave reeking after it was flooded with excrement that was left by migrants who used drains as toilets.