I got a relatively inexpensive macro lens (Tamron 90mm ~$450). I use it with my Canon 50D. I adore it. I just posted a macro thread if you want to see the results.
You may want to look into extension tubes as well. I just ordered a set, and they are extremely cheap on the Ebay. Well, I suppose I shouldn't recommend them until they come and I know they work!
