Multi-million pound deal will see derelict Black Country site brought back to life