Council, support agencies welcome social housing project near city centre