If I wanted to play with this sort of thing, and assuming an SLR camera, I'd probably just use a cheap magnifier lens, handheld in front of the camera. Probably attached to a black card, mainly to exclude a lot of the extraneous light. If you wanna stop it down just cut a hole in some black paper and tape it over the lens. (Stopping down, smaller hole, will drastically increase the quality of the image.)
Of course, if you already have a bellows attachment (per xkaes) for your camera, this would give you a much more stable platform.
You might want to shoot for a sorta "normal" focal length of about 50mm/2 inches. In magnifier language this would be probably around 5X. These lenses will probably be biconvex (both sides bulge out), not meniscus, but if you're just playing, does it really matter?