For macrophotography, you need as big an aperture as possible. So probably your existing 50mm lens will be the best. Get yourself a set of Canon extension tubes which go between the camera body and the lens unit. They're designed specifically for macro work, cost many times less than a new lens unit and can be combined to give exactly the magnification you want.