This £3.4m makeover of a former basement gymnasium by 6a Architects, adding two new floors, gives a new public face and facilities to a building run by the Holborn Community Association. Lucy Bullivant paid a visit