First off, welcome to the Forum.
I have the Canon EF 100mm f/2.8 Macro lens, and I love it. It's very sharp, and not too expensive. The AF is very quiet, and pretty fast compaired to my kit lenses. Not as fast at my L lens tho. The fast aperture is great for isolating subjects with a shallow depth of field too.
Another more inexpensive option would be a set of extension tubes. Loupey, one of the moderators on this site, put together a great thread that shows what extension tubes are capable of. You can read that thread at this link:
Extension Tubes - Full Disclosure