Dick Dodd of The Standells, who sang ‘‘Dirty Water,’’ lives in California but has been a Red Sox fan for years. He said he couldn't wait to play Fenway's signature celebration song on the field.