'Catastrophic' flooding to hit California as bad weather continues