Wait, I think I dated a girl named Sharon Connecticut!
Your best best is the Housatonic River. Head to Housatonic Meadows Fly Shop and see Marty. He will set in the right direction for one of the finest rivers around. Check out the website flyfishct.com. He will tell you when not to go as well.
Enjoy!