Can I sneak in a water bottle

Yes

I think everyone usually does.

I took in a small one in my see through bag and they let it through.

Not unless it's down your pants they do a pretty thorough search and pat down

To sneak something in sounds like you're doing Something wrong