A historic County Durham park which attracts 450,000 visitors annually is set for a "giant" tower which will be "the only one of its kind" in the UK.