Ok... is this being used as a webcam, or a security cam? Do you want streaming video, or photos every 5mins? Indoor or outdoor? Easily accessible, or set and forget?
My recommendation would be to get an IP camera that can be directly connected to the internet. For under $300 (last time I checked) you can pick up an IP camera, with a web interface, that will upload pictures to an FTP site every x mins, provide streaming video when logged into the web interface, and has servo motors so you can pan + zoom remotely via the net.
The great thing about an IP camera is that it really is "set and forget", you can get weatherproof outdoor enclosures if required and you don't need to worry about a PC falling over (or associated costs).
My recommendation is to find a local security company and go have a chat to them, chances are they'll have the latest and greatest in IP CCTV + HDD DVR technology. They might not sell you a single camera (or try to overly inflate the price) but you'll be able to see how the professionals do it, and then eBay/Google till you find something yourself :)
(oh, and for super geekyness... get a camera supporting Power over Ethernet)