This is a 'no-go' for a DIYer. Your light globe will likely not be heavy enough to use as you wish. Additionally, the glass must be tempered for safety. If it were tempered, it could not be drilled for a drain. Better stick with factory manufactured products for this type of project.