If you can be bothered (and are allowed) to take a tripod, any lens will do this easily. No need to spend anything. Just use a long shutter.
If it needs to be hand held I agree with whoever suggested getting something with VR/VC/OS. A nice wide aperture zoom or prime might gain you a stop or two but the best VR systems can give you up 5 stops. Makes a massive difference. Not as much as a tripod though!