We have both of the Thermos ones the PP posted. The top straw one doesn't usually leak, but isn't the best for tossing in lunch or other bags because it has leaked a few times this way for us - could have been operator error though. The bottom ones rock and we've never had them leak under any circumstances. We also have these and like them.
http://www.thermos.com/products/sipp-hydration-bottle-with-black-lid.aspx
Used to use the Camelbaks all the time, but found they start to leak after a while, so now they only get used when not likely to be upside down. If you prefer to drink from glass, these are cool:
http://www.lifefactory.com/adults.html?gclid=CKrJr-HAybICFYKK4AodMQ8ADQ.