With proper care, a water bottle should be able to last for years.  Stainless steel options might be the sturdiest option if you're expecting them to really take a beating.  In the long run, taking care of a reusable water bottle that will last several years will make a financial impact over purchasing disposable single-use bottles, and will make an even bigger lasting impact on our environment.