Those are some awesome, beautiful pics.

I hope the OP will chime in, but it's very likely he used a tripod and I would guess a shutter speed of around 1 or 2 seconds based on the glassy-smooth surface of the water and the relative brightness of the natural and man-made light sources. It's possible a super-long shutter speed wasn't necessary, though, just creative color balancing and nailing the perfect exposure. The almost unearthly rich orange color of the street/path lights on the opposite shore indicates he tweaked the color balance to reduce the very deep blue of late twilight sky to a more familiar "daytime" blue. Getting the exposure of the sky perfect like that, while knowing that you will also have detail in the artificially lit areas, typically involves using a spot meter, or having so much experience with one that you can judge the balance by eye. And waiting for the right time of day

However I have seen comparable results from high-quality point-and-shoots under the right conditions. White balance on auto, center-weighted auto metering, a steady hand and a good eye, and you can get some great shots that are similar.