Local Enterprise Partnership funding provides new homes Derelict Kingstanding pub site to be transformed into affordable housing.