Any metal water bottle will last you way longer than any plastic one. I only use a flexible reusable plastic one when mountain biking. If I have a metal water bottle on the holder it will get destroyed by the time I descend to the bottom of the hill.

I personally use a hydroflask. I know its pricy, but the design is nice. It is susceptible to dents and what not, but it still holds water fine. There are plenty of cheaper waterbottles that are metal and are as of if not better quality.