after the inital investment, it's cheap too ;)
Solatube I think is one brand, that has a parabolic lense and mirror system to gather in light and bring it straight down
only problem I guess would be, cloudy days
also if you rely on sunlight completely, you would not have water depth...