The gold standard for party bongs is shitpipes. Dunno about other places but for a Euro standard one, you need, bottom to top, 1x 100mm end cap, 1x 100mm sleeve (pipe to pipe coupling), 1x 100mm adapter to 40mm (the 100mm side should fit the sleeve), some length of 40mm pipe, some means to drill two holes, and two things not available at any random hardware store: a preferably metal what’s it called in English the thing that goes into the water and some tissue to tighten that metal thing in its hole, wrap in a taper and twist in. Try to get an adapter that’s angled, there’s also ones with a flat step instead of (quite aggressively) tapering the diameter.

Completely and utterly indestructible at least when it comes to banging it up. In principle also fit to handle acetone those Euro standard pipes are polypropylene but I wouldn’t push it. Tons of water in there, definitely bottom-heavy, and very light when empty.