As long as it's not too bright, it's OK.
The blue moonlight tubes look nice, but I don't really know how people see them as realistic, does moonlight really look like that in shallow rivers/ponds?
I've been told by lots of people that fish cant see red light, and I know for reptiles you can get red heat lamps that are to heat the enclosure at night (they seem pointless to me though).
So if you have a choice of colours I'd go for red. I wouldn't get LED's though, I would go with this super-cheap method here:
<a href="http/www.fishforums.net/content/Hardware-Do-It-Yourself/46380/Cold-Cathode-Moon-Light/" target="_blank">http/www.fishforums.net/content/Hardware...ode-Moon-Light/</a>
I've done it with white lights for day time viewing, it's really easy
.