Footage shows the party street submerged by the heavy rain