There really isn't any adhesive that will bond to polyethylene, that's what most of the cheap plastic tubs are made of, it's also what the container that holds most adhesives is made of. I've seen plenty of sumps built that didn't need anything glued to the tank though. I'd go for it, but consider creep, the phenomenon that occurs when a load is placed on an object for an extended period of time, as the name suggests the material will begin to creep, or deform under the load slowly. Normally creep is only an issue at elevated temperatures, but with plastics it happens at room temperature. I've seen people solve the problem with solutions ranging from sticking the tote in another tote for reinforcement to building a frame around the tote to keep the sides from bowing under the weight of the water.