My kids had CamelBak bottles when they were younger, and they held up really well on many outings. There were several cute patterns as well. If I remember correctly, there was a straw that flipped up for drinking. CamelBak and Klean Kanteen water bottles are 15% off this week if you have the Target Circle App. That will help with the affordable part.
My kids have use these. Even after daily use for over a year they have held up great! They are leak proof and insulated to keep your drink either warm or cold. They come in lots of fun colors and several different sizes. I love them!