Here are some hotel options in both Hood River and Portland. There are also Airbnb and Vrbo options in the Hood River area.
There is public transportation from PDX to Hood River.
If you are traveling in Portland, using the Max Light Rail is a wonderful way! It can also get you from PDX to Gateway Transit Center where you can take the Columbia Gorge Express bus to Hood River.