Where is a good place to camp in oregon ?

[portland379]

I want it to be somewhere near water and where adults are okay to drink. Any suggestion is a good one. Thank you