Fremont has a snifter and a can glass, and hey, their beer is worth the visit too. Black Raven's Willi Becher is also pretty cool IMO. Bottle shops and some grocery stores will have small selections of various glasses, but I don't know of any outstanding glassware mecca in Seattle.