You can make pictures like these with a cheap compact camera. I think every compact camera has a peset named "fireworks" or something like that. In that preset you can actually set the shutter speed. This way you will have sharp pictures with great contrast.
Now you just have to find some places with street light or if you have full moon that is even better.
These where boats with different color lights.
Full moon at a wine festival.
The power of full moon at night.
These are wooden pillars in water.
Enjoy making your awesome night photos!