Is this camera compatible with all Raspberry Pi Models?
No, it only supports Raspberry Pi Zero and Zero 2w.
Do I need external IR LEDs if want to use the camera in complete dark?
Yes, IR LEDs are required if you want to use it for night vision projects.