I like the picture, I find the colors very interesting - a very warm/yellow scene with the cool blue light of the tree and it's reflection on the road popping out, I find it very pretty.
The only thing that irks me about the photo is the second intense blue light over the pub which seems to suck my focus away from the rest of the scene.
Still, the shot gives me a nice feeling overall.
I think the issue here is that there are too many things going on compositionally. Too busy. There are several shots within this shot. A better approach to this type of situation (where the light is stable) may be to move in, explore, and pick out simple compositions. Isolate your ideas. That may help to define how you feel about the shot.
The one thing I would've done different in this shot is to use a smaller aperture. The larger light sources are nothing more than blobs here, and using a smaller aperture would help to rectify that. It would of course require a longer shutter speed, and I'm not sure what kind of time you had for that shot - possibly would've gotten light trails from traffic going by? But as long as that traffic light stayed red long enough you might be ok.
Also, the lens flare above the street light is annoying - I'd clone that out. The lighter flare below it is ok with me.
Yeah, I've not touched the shot since I took it last weekend, I think I see some cropping opportunities here. Thanks for the responses everyone. I'm gonna go toy around with the image and see what else I can come up with, and maybe do a reshoot before the tree comes down. Thanks again for you replies.
Ugh to the rediswh sodium street light colour and it is very hard to remove it - so I would go for this sort of colouring
But if you are doing it again - try bracketting the shots and then you can pick/clone the bests bits in so that there are less blown areas. And I agree with the others that you need to have a better composition to lead the eye into the picture.