The leader of Dumfries and Galloway Council has backed plans for a major Borders sculpture which hopes to become an international cultural landmark set to rival the Angel of the North.