The pi actually supports USB webcams at least, so I'd be willing to be most USB cameras work (obviously don't quote me, just guessing). Back when we did the project we had to wire one to the GPIOs and build a circuit - but support was really limited back then, a webcam would've worked way better...