While it may be second edition, with some elbow grease and a knack for conversion, I strongly suggest going to RPGnow.com and getting as many PDF's of the old Lankhmar material that you can. Nearly every adventure is city based and geared toward rogues.
If you are not familiar with Lankhmar, it is second only to LotR in regards to influence over the formative years of D&D. In all honesty, I'd say that the nitty-gritty aspects of the game owe more to Fritz Leiber than they do to Tolkien. Go to the library, get Ill Met in Lankhmar, and read it.
While the setting is very different (no demi-humans and an entirely different way to do magic), if what you are looking for is urban stealth-based adventuring, you will get all the inspriation you need from the Lankhmar material TSR produced in the early nineties. Hell, you might be able to find some of the actual books on eBay.

Ditto what thathatedguy said.

There was a module once upon a time, dating myself, back in Dragon magazine, called The Assassin's Run, if I remember correctly. Couldn't tell you what issue it was but I think it was either in the early 1990's or the late 1980's.