Council’s latest successful bid to Youth Investment Fund will provide for renovation and new resources at much-loved facility