Super nice re-purpose of a glass light shade by Storing up my treasures. I really like this and I bet it is gorgeous when the sun hits it.
DIY ART Upcycle
http://storingupmytreasures.blogspot.com/2010/07/glass-shade-garden-lantern.html
You could drill a hole in the bottom for the water to escape.
http://www.designmom.com/2010/11/diy-bottles-full-of-light/