You can browse ic.org (intentional communities) for places that might fit what you are looking for. You mention an agrihood, so you might want to search for ecovillages. I don't know that Connecticut has any intentional communities, but there are several in Massachusetts, Vermont, and New Hampshire, plus a few in New York, that might be within acceptable distance. Good luck!