According the the official website of the MassachusettsDepartment of Fish and Game, www.mass.gov/dfwele, trout fishing is found:
Hoosic River in North Adams and Williamstown
Housatonic River in Great Barrington, Lenox, Pittsfield and Stockbridge. There has been extensive PCB remediation in Pittsfield and there are concerns about the Housatonic in Lenox. It is not recommended to consume fish from the Housatonic.
Laural Lake, Lee
Lake Buel, Monterey
York Lake, New Marlborough
Big Pond, Otis
Onota Lake and Pontoosuc Lake in Pittsfield
Windsor Pond, Windsor
Richmond Pond, Richmond
Stockbridge Bowl, Stockbridge
Goose Pond, Tyringham
There are numerous streams in Adams, Cheshire, and Savoy that support trout, but you'll need the goodwill of a local fisherman to find them!
None of these place are in Sheffield, but Stockbridge, Great Barrington, Monterey, New Marlborough, Otis and Tyringham are all relatively close by.
I hope this helps.
You may find additonal info on www.mass.gov/dcr/watersupply/lakepond/lakepond.htm.