Most digital cameras have a closeup function on them, it is the symbol of a flower on the selection wheel. I have a Kodak easy-share 4.0 mega pixel camera that I got 4 years ago (if you see any of my posts, I used this camera to take the pic's), I want to buy a new one with more mega pixels. I would suggest not getting one with less than 4 mega pixels though. But unless your a professional photographer, a basic digital camera will do just fine. Just remember to check if it has the flower icon on it.
Oh yea, also to get giant size pic's in your posts, I upload all of my pics to http://flickr.com/ , then when I want to use them in a post, I just copy the page address of my picture and it is super sized. (unlike if you were to upload a photo directly to this page, it has to be within a certain size)
here is some of the close-up pic's I have taken: just click on the pic's to enlarge them...
http://farm3.static.flickr.com/2113/2412804408_0d7dbf3190_b.jpg
http://farm3.static.flickr.com/2246/2412804152_8a4e1f3ce3_b.jpg
http://farm3.static.flickr.com/2036/2411980981_e8b5e7a212_b.jpg
http://farm3.static.flickr.com/2043/2414821481_f2db1b54d3_b.jpg