Please welcome Eyoyo Underwater Fishing Cameras.https://amzn.to/3siEgXn
PVC or CPVC will be your cheapest option. Some .050" wall 6061 tempered aluminum tube would be the best but you will pay for it.
What is CPVC?