Blackrock,
You'll really love Bonaire. I was there last year around Christmas...and will be there again this year. 2 weeks there will enable you to get a really good feel for the island. Last year I brought a novice diver college roommate along. He had only completed his OW dives prior to our trip. To make a long story short, he did great. He gradually increased his max depth during the course of our stay and even did a night dive. I'm sure you'll do fine, too. I really don't buy into the hogwash of getting the AOW certification to become "certified" to do a night dive. For certification purposes, PADI AOW requires students to read 17 pages in the book and do a grand total of one night dive. In my mind, a lot of night diving is really just common sense:
(1) Use a dependable primary light source (fresh batteries are good)
(2) Have a working backup light with you (test it before the dive)
(3) Take along a compass and know how to use it
(4) Do the identical dive site in the daytime FIRST
(5) Review communications/hand/light signals ahead of time with your buddy - some helpful signals are: (a) slowly make a large circle with your light to indicate "OK", (b) move the light back and forth horizontally rapidly get your buddy's attention in an emergency, (c) shine the light onto your other hand to give the usual dive signals, (d) be careful never to shine your light into your buddy's eyes - it could blind him!
(6) Scout out the site on a previous night to see what kind of lights will be shining to help guide your exit.
Having done some night dives on Bonaire, I can tell you that you don't need to plant some lights on the beach ahead of time to help guide your exit. You should be able to figure out where your truck is parked on the beach relative to the street/house lights on shore. (This is where surveying the site on a previous night helps.) I realize that the PADI AOW book recommends leaving lights on shore to mark entry/exit, but I've always thought that this is a great way to get your lights stolen. As divers who visit Bonaire know, petty theft is an issue on the island.
Tank marker lights are useful to differentiate you and your buddy from the other divers enjoying the same dive site at night. I wouldn't say that they're required, though.
As has been mentioned, one of the challenges of night diving can be orientation. Know how to use your compass and ensure that you're heading east (toward shore) at the end of your dive. If you follow the contour of the bottom as you swim in, you'll be sure to do a 3 minute "safety stop" while still swimming in and checking out the cool night critters. Pretty much all of the dive sites in Bonaire allow one to swim right up onto the beach if necessary. The only bit of cautionary advice I would give is to be careful during the exit. The "ironshore" is laden with potholes. I gave my buddies a good laugh when I inadvertently turtled myself. Hard-soled booties are a must in Bonaire.
I would encourage you to listen to the helpful advice of Damselfish, dwallace, sjspeck and TSandM. All of them made excellent points in their posts. Conditions are so good (viz, sandy bottom) in Bonaire that I can't think of a better place to learn how to do night dives.
I wasn't able to do the Town Pier night dive last year. I'll definitely be doing it this year.
The only other bit of advice I have is to get Nitrox certified beforehand. The outfit that rented us tanks/weights for the week offered a free nitrox upgrade during our stay. We're looking forward to taking advantage of this deal again.
Enjoy your dive trip and be safe.