Is there an active expat community in the Azores, and on which islands?

Yes, though it's small and spread out. The most active communities are on São Miguel and Terceira, with smaller groups on Pico, Faial and Flores. Much of the social life happens through Facebook groups, local associations and cafés rather than formal clubs. Joining a few online groups before you move is the easiest way to connect.