I concur with what Ras Walleye said

We just went there in October, it was awesome.
They say the best time to go is during a new moon, or after a very sunny day (no rain) and a dark night (aka, new moon because it doesnt give off a lot of moonlight). That is when you will see it the best

But we went after a rainy day, actually it was raining while we were there and we were still able to see it. I would say it is definitely worth seeing, very VERY cool!

Here are some tips though:
I highly recommend getting in the water, it makes the experience much more cool!
But if/when you get in to swim I would suggest having some water shoes on. The water is shallow and full of a lot of silt (sand) so it gets murky and a little hard to swim in, and kind of mushy feeling (if that makes sense) so the water shoes made it easier to deal with.

It was very hard to capture it on film (and I really wish we could have gotten some pictures of us in the water) but here is one that does show the bright blue color that it gives off in the water

Name:  gw2.JPG
Views: 338
Size:  33.2 KBName:  gw.JPG
Views: 257
Size:  41.5 KB