Urban areas at most risk as Sepa issues flood alert for Dundee and Angus amid Met Office warning for thunder