Sherborne’s almshouse will transform into affordable housing, community projects, and a tearoom, ensuring this historic site stays a community hub