Personally, like I did on a starfield map, I would recommend using simple white dots placed randomly. Photoshop have options to randomize the point placement in the brushes options.
Lower the opacity of the layer and you should be set.
Large cities also tend to have a glow effect around them.