Homes, businesses and roads across Flintshire and Wrexham were inundated with water