The most effective way to do it doesn't really come from post processing, it comes from watching how night shoots look then replicating the contrast in camera first Proper technique in production will yield some nice results, but would typically be better suited toward certain projects. Sci-Fi, Fantasy, etc.
.