The real questions are how much you want, exactly. If you're looking to start a campaign with a single module, or get a whole campaign out of a module/series of modules, that's one thing. If you're looking for something smaller, like 4-5 5 hour sessions or less, that's something else

Lastly, what levels you looking at? I'd advise you not to start over 10th level, as this is your first time DMing, but if all of you are familiar with the rules you may wish to start higher than 1st (I personally hate levels 1 and 2, but you guys may really dig it

) Also, what ratios of hacking to acting to do you want? Answer all these, and then you'll have three or four options that will be good for you.
My suggestions:
Wizard's Amulet + Crucible Freya is a good 1st/2nd level deal that will last a few sessions. If you want to run it, just pay shipping and I'll mail you mine
If you are unsure of how far you want to go with this (as in single adventure vs campaign) Freeport is a very good option. Death in Freeport (a 1st level adventure) is reputedly stellar, and it has a string of modules following it all the way up to 11thish level. Think it goes Death in Freeport, Terror, Madness, then Black Sails. Note: If you go far with it it's pretty piratey, so if you don't like swashing buckles then it's probably not for you.
Banewarrens (Malhavoc Press) is really, truly awesome, in my opinion. Lots of hacking IF YOU WANT IT, and lots of RPing if you want it (We didn't want the smacking, so we didn't). 6th-10th level, can get it as a PDF. May be difficult for a starting DM, not sure, but it'd probably be better than...
Return to the Temple of Elemental Evil: Everyone else who's reading this is laughing at me, because this things a monster. However, this was MY first time DMing, and it went alright. You want a well-written campaign in a box for 3rd edition, here it is. Of course, I would never have been able to do it if I hadn't had the support of the messageboards on Monte Cook's website, and if I were to do it again I would replace the Crater Ridge Mines with the Banewarrens (yeah, it works, look on the forums

) Again, act or hack, whichever you want, it can be done with this module.
Ah crap...got done writing all that and reread your post. You wanted a low level, not overtly long adventure. Emm...Yeah, Freya or Freeport. Maybe the Shackled City adventures out of Dungeon magazine
Whoops,
Eltern