Kingston has one of the oldest 2 rail clubs in the country. Their layout is impressive, with multiple main lines, a traction line and narrow gauge division.
Honestly. I don't know of any clubs other than modular groups right in Albany. Rpi has a model ho layout, but it's not open to the public.