i use this one.. it's $150 at staples. It takes decent macos. http://www.usa.canon.com/consumer/controller?act=ModelInfoAct&fcategoryid=183&modelid=17479
Doesn't have to be anything expensive ... many digital cameras have a "macro" setting for photographing small items.
Take a look at my link, these were taken today, using just an old 1.2 mega pixel camera and its not even mine! Macro, its great.