To the south, of Corvallis, is Kiger Island slough (part of the Willy system). And just a bit farther south, is the Long Tom River. Lots of private land; but some owners will give permission if you ask.
Then, even farther south is Fern Ridge Reservoir.
North, is a small pond at Adair (next to the ODFW offices).
To west, is Bonner Lake...just west of Fort Hoskins (Kings Valley area - about 40 min. from Corvallis).
An hour and 10 min. west, is Olalla Reservoir.
An hour and 20 min. west, is Big Creek Reservoir One (lower of the two).
Good luck.