Former Aberdeen manager Sir Alex Ferguson says his old club can be successful again with the opening of their new training ground.