Dirty Dick's
One of the better known pubs although definitely no tourist trap near Liverpool St, supposedly named after a Georgian dandy who let himself go on the death of his fiancée.
Lamb Tavern
One of several pubs in Leadenhall Market where you can listen to insurance brokers from nearby Lloyds talk business.
If you just want to see the sights, come to the City whenever it suits you although check the opening hours for anything you particularly want to see. If you are spending more than a few days in London, visiting the area at night, especially around 10PM-11PM, can provide a decidedly un-touristy atmosphere. You will be seeing part of London life that few people who do not live or work in the City experience, and if you have the confidence to introduce yourself you may even get into conversation with local workers out for a late drink, the area is enough off the tourist route that you will be something of a novelty. Thursday and Friday are naturally busier but at the same time a bit less friendly, earlier in the week it may be dead but you have more chance of meeting locals just out for a drink.