Dundee eyesore will be transformed in multi-million pound in