Hyper-scale facilities driven by AI investment are putting energy infrastructure, water use and jobs at the center of the debate in Scotland.