What submersible adhesive is watertight and durable?
I would think a marine grade epoxy should do the trick for you. It would definitely be waterproof and it's made to hold up under the stresses of a moving boat, and to hold up to salt water which is much harsher than the fresh water in your rain barrel