I decided to try and keep the feeling of night but also recover some details. I started with two versions of the raw -- one that recovered detail evenly and then one that blew out the city in exchange of getting nice clouds.I removed the city and sidewalk and other lights and kept the clouds, tree, and water. This allowed me to blend it in with a linear burn and, I think, 31% opacity to recover sky detail. Then i copied the background, the whole image layer, changed the blending to luminosity, and made the now-middle layer black and white. Using the sliders, I made the light sources the proper, I felt, tone and brightness. Then i flattened it all.
Then I balanced out the hues a bit to make a more-uniform color scheme image-wide, including correcting the sidewalk for white. I left a bit of orange there to give the image some warmth. I duplicated the layer twice and blended both new layers as overlay. One I ran a high pass at 12 over, which made the lights in the city and tree leaves pop but left most of the rest of the image alone. The other I left as-was and changed the opacity to 4%, which tweaked the lighting slightly.
All that left a dark halo around the primary street light. On the bottom layer, I used a 20% dodge for shadow areas to dodge out the halo the best that I could. I flattened the image and voila!