I've used some non-USB cameras from http://www.e-consystems.com
with Gumstix SOM computers, and they had fairly decent Linux drivers for their products interfacing with the image port of the Gumstix. I would expect their USB camera range to have equally good or better driver support. What is your motivation for using USB? Zynq can interface to pretty much any camera, from the expensive high resolution global shutter VITA sensors to the low cost Aptina/OmniVision sensors. If you google Zedboard+OV7670 you should find a project to get image from a cheap image sensor onto Zynq, directly without USB.