The Philips 900NC webcam is Linux compatible (Tested with: Ubuntu 8.10, 9.04 & 10.04). Under V4L2 it supports 640×480 at 15fps out of the box. (The webcam’s box claims speeds of up to 90fps, but that is only for smaller resolutions, custom windows drivers, etc. You may be able to get better speed with an optimized Linux driver, but out of the box performance is satisfactory.) It supports ZoneMinder, but only if you set up the exact correct Device Format (NTSC M) and Capture Palette (YUV420).
It has good low-light performance, although it will not work in complete darkness without additional IR illumination.