I've built this dry hopper and found that it works well attached to the 1.5" triclamp at the top. A bit pricey, but solid, should last forever, and gets the job done!
https://hazyandhoppy.com/my-diy-dry-hopper-for-homebrewing/
For a slightly less expensive version (and also less robust)...