It's going to take you a couple of fishing trips to get the whole bank fishing technique down "assuming you've never bank fished the Columbia" your headed in the right direction by signing up on Ifish, there's a lot of great people here that are willing to help.
For now you can run a search on this website, the link is under the Doherty Ford sign located above this post. (search the 2002-2001 archives) If you don't find what your looking for then you can e-mail me.
If I were brand new to an area and fishing fish I was unfamilar with I would hire a guide. For the app. $150 you will save money in the long run and have a greater chance of nailing a fish. Lots of guides here at ifish, you could email them and ask if they are working the area.
If guides are not your way to do things two rivers come to mind Clackamas and Sandy. Both for coho, albeit the Sandy will have chinook they are not legal to target and keep.
Just reread your post, since your hitting the bank lower Sandy River(below Oxbow, preferably Dabney SP to Lewis and Clark SP) has lots of access.
Lures are wide open-#4 metric type,drift corkie and/or yarn, even eggs.
Can't tell you about sturgeon but others here will and I am sure since your stay is temporary the gear to get set up would not be worth it.