While the terrain will be the same, the inhabitants will have changed. Many of the more elusive creatures you have difficulty seeing during the day will be freely moving about after dark. The aquatic realm has its "day" life and it's "night" life too, and believe me it's a hive of activity.
Excellent macro opportunities for those budding photographers and for those who just like to watch and interact with the aquatic realm, you will witness amazing sights. Imagine watching a yellow moray eel having its teeth cleaned by a cleaner shrimp, or the inquisitive crayfish rummaging around in the open looking for tasty morsels!
Activities such as naturalist, reef diver and underwater photography also provide great opportunities when combined with diving at night. This is a lot of fun!