In general, you only want to put a fixture directly over water if it's designed for that purpose. It's absolutely essential to have a barrier between the water and the bulbs. One splash up into hot bulbs and *boom*... a big, sharp, wet mess.
I have an open top tank with a raised compact fluorescent fixture and it looks great.