This is The Stamford Arms in Stamford Street. It is run by our friend Roly. 

Our friend Chris, however, has a proper grown-up job.

We saw in the Millennium here (though Steve insists the Millennium started the following year), drank champagne, watched the fireworks and eventually walked back to the hotel we'd booked through a sea of drunk but cheery people and empty bottles.