1000 what - the country your in would help since it might drastically affect how much spending power that actually is.
As for a recommendation I would say go Canon. Not because I'm canon shooter, but because if macro is your aim and your love then there's a chance that if the bug bites hard you'll want to start getting more and more magnification. Canon produces the only lens that goes beyond 1:1 magnification on the current market (1:1 is the standard most macro prime DSLR lenses get to) and then goes on to 5:1.
For an idea of what that means in real world terms here's a 0.5:1 which is about what you're getting (if a bit more) with your current camera:
And a 1:1
And a 5:1
(that bug is somewhere around 2mm long at most and likely shorter).
Note these are not exact, but close enough.
However that is long in the future. For now I would suggest a DSLR camera body combined with a macro lens of 90mm or longer in focal length. Note that for macro photography what you want are prime lenses (single focal length - ergo no zoon) as whilst there are zoom lenses on the market with "macro" in the name they, at best, only get to the 0.5:1. It's more a close focusing setup than proper macro (its just used for marketing).
A few suggestions on lenses would be:
Tamon 90mm f2.8 macro
Sigma 105mm f2.8 macro (original second hand - or the new with OS)
Canon 100mm f2.8 macro (original second hand)
Canon 100mm f2.8 IS L macro (new but very pricy)
Sigma 150mm f2.8 macro (original second hand - or the new with OS)
Sigma 180mm f2.8 macro
Note whilst some of those are out of production and now second hand only they are still top rate lenses, the new versions having only very minor gains optically over the former versions. Macro lenses are sharp and well made across the board so optical quality is normally not a concern unless you're being very picky.
Camera body wise mostly any body that fits into your budget would suit for this kind of work - from Rebel entry level up to midrange bodies. If you get reconditioned or second hand you can save some cost (reconditioned are basically like brand new - they are oft old demo/display cameras and all are fixed up by Canon before being sold as reconditioned so they are good as new).
Ontop of that I'd suggest a speedlite flash - this helps give you more lighting control which will really help in macro photography. An own brand like a 430EX or a 3rd party speedlite (I can't recommend models but I'm sure some will chip in with suggestions) would suit and can save some money over top end options.
Once you've got that basic core kit you might look to something like a Lumiquest Softbox or similar sized softbox to fit into the flash directly to soften the light (note those cheap omnibounce options don't work for this kind of photography - they work by making light bounce around a room making the walls the source - but for this you can't do that so you want a softbox to make the light source (relative to subject) bigger and this soften the light).
