The camera works with all models of Raspberry Pi 1, 2, 3 and 4. It can be accessed through the MMAL and V4L APIs, and there are numerous third-party libraries built for it, including the Pi camera Python library. See the Getting Started with Pi camera resource to learn how to use it.
The infrared Raspberry Pi Camera Module 2 NoIR replaced the original PiNoIR Camera Module in April 2016. The v2 Pi NoIR has a Sony IMX219 8-megapixel sensor (compared to the 5-megapixel OmniVision OV5647 sensor of the original camera).
The Pi NoIR gives you everything the regular Camera Module offers, with one difference: it does not employ an infrared filter. (NoIR = No Infrared filter.) This means that pictures you take by daylight will look decidedly curious, but it gives you the ability to see in the dark with infrared lighting.