Most all digital cameras take good macro shots.
The key to good macro photography is lots of artificial light and a tripod.
While you are looking, you should also read a bit on "close-up" or "table top" photography:
Since small digital cameras cover such a large price range, it would help to know what price range you are interested in.
Also, do you have a preference for the amount of optical zoom and megapixels.
Optical zoom is 3X on the majority of digital cameras, but some now reaching out to 15X and 18X (Sony and Olympus)
The majority of cameras now, are 6 megapixels or more.
I am planning to buy a compact/ultra compact digital camera with good MACRO facility. Please suggest me some models..