I'm currently using several Axis 2100 cameras and I think they're great. They can very easily be hooked up to a motion sensor like JiNG described. These cameras have been mentioned several times here on slashdot and you can check them out at: http://www.axis.com/products/cam_2100/ If budget permits (they're about $500 USD each) I would give this camera a try.
Slashdot Mirror
I'm currently using several Axis 2100 cameras and I think they're great. They can very easily be hooked up to a motion sensor like JiNG described. These cameras have been mentioned several times here on slashdot and you can check them out at: http://www.axis.com/products/cam_2100/ If budget permits (they're about $500 USD each) I would give this camera a try.