A former oil industry testing site in Bridge of Don, Aberdeen is to be transformed into a major energy technology hub.