Dramatic footage shows water overflow in flash flood