The storm brought record levels of rain to the region, forcing New York City to issue its first-ever flash flood emergency