Ha ha ha...Yogi was da man! You have a great outlook.
Seems like fly fishing would largely be a stream thing...unless you have a flotation device for lakes. I've watched peeps fling their bug wands, from lakeside banks. But that didn't look very effective to me.
I'm not familiar with the Astoria area, but thes might be worth a go:
Above Youngs River falls
• Catch-and-release all year
for trout, artificial flies and
lures only.
Above Saddle Mt State Park
access bridge (on Lewis & Clark River)
• Open all year for trout.
• Catch-and-release only.
• Artificial flies and lures only.
That's all that I can find with a quick mapquest search, and looking at the online ODFW reg's. I'll have to let others take it from here.
Tight lines and let us know where you go, and how you do.