Two people have died and another is missing after heavy rain caused flooding across Catalonia, with firefighters responding to more than 1,500 calls.