A badly vandalised business park is set to be developed into new flats and homes after officials said there was “no realistic opportunity to develop the site for business.”