It's not exactly in New Haven ( Which is why i said watch the maps). Any bike will do but ALL; the trail is paved (except) for the off the road section in Simsbury)
Southampton has a dirt section and there are plans to hook this up with the finished sections.