Torrential rain and flooding across southern Spain have left dozens of people dead and many more stranded as emergency services battle to reach isolated areas.