I'm assuming that you have access to a car....
When it rains, as it has been, there are lots of rivers that run within 2 hours of you, throughout Connecticut and the very southern part of New York.
My local river is the Housatonic. Bulls Bridge is epic when it is running high, and a very nice class III when running low. People at Clarke Outdoors have a pretty good idea of what is going on there.
some websites:
www.clarkeoutdoors.com
www.clarkeoutdoors.blogspot.com
www.totalwhitewaterfun.blogspot.com
There is also great low water park and play in Tarrifville, Connecticut on the Farmington river.
How close are you to the ferry?
Rain brings up a fun class IV creek just north of Bridgeport, Connecticut
We'll look around at teh HACKS club house and see what is available to help kit you out.
How long are you here?
What type of boater are you?