ah... macro... that'll be nice after many street outings.
Does insects come out in the evening? If they do, I really want to suggest Lower Pierce or Seletar reservoir (sunset shoot with macro).
But a night shoot is probably something we've not tried. Where's a good place for a night shoot? The Christmas lightup? eh... super crowded man. I was there on Saturday night after Quantum of Solace, and I guess you may have to think where to place the TRIPOD, and start thinking of making sure someone doesn't try to squeeze past and accidentally knock your equipment over.