Something similar can be achieved with an insulated roof by using an insulated tube with triple glazing on the interior of the house and and a glazing or acrylic dome on the exterior of the roof. It is not water or a bottle but the idea is the same, catch and redirect light. The bottle is effective because it disperses the light in all direction whereas a skylight only lets a straight beam of light in. An expensive alternative to this would be fiber optics or even solid acrylic.

I love the simplicity of this invention. When I first heard of people doing this I was hesitant to believe it, but it really is amazingly effective, and makes me wonder how we could use skylights or tubes more effectively.