Majestic Construction has been appointed to support the transformation of rugby league club Huddersfield Giant's Flair Stadium in Dewsbury.