The one in the YouTube video is at the old quarry located next to Wolf Hill Forest Preserve. Not really a waterfall, just a rock face that gets occasional runoff. It super cool though, especially when the runoff freezes and it becomes covered in icicles.

The actual waterfall is at Ken Weber Conservation area near Waterman Lake. Same town but a decent distance apart.