Flash flooding across Spain killed more than 95 people after torrential rain left towns and villages submerged and turned streets into rivers.