As far as I know, the external iSight is the only other camera that is natively usable other than the built-in one.
However, there is software that allows you to use a USB camera with iChat, see
here. Other than that, I don't know how to get a USB webcam working. There may some free alternative somewhere...
Make sure your webcam is compatible though.