In that area, I can't think of any hotels off the top of my head. It's in a parkish area if that makes sense. If you look at the location on google, it's all green. Part of the problem is that the museum is in an old army barricks area that was transformed. If you're renting a car during your stay that would be easier. You can take a taxi, but make sure that you get the main number to call them back when you're done. Buses aren't really that plausible either ~ same reason as the taxis. Something you could look into are the Zip Cars. I know they have them in the city although not sure about locations. If you stay in a hotel downtown somewhere, you could rent those for the day or a couple of hours and drive to the museum.
On a side note, the museum is really cool. In the backdrop of the museum is the bridge, and you can get some really good pictures there. There's also a restuarant near the entrance to the parking lot area, or really close by, that has some good food and if the weather's good, you can sit outside looking out to the water and the bridge.
Hope that helps. Have fun if you get out there!