Roads turned into rivers as houses devastated, customers trapped in pub - and new warning in place as rain continues to fall