An ancient yew tree rooted in the myth and legend of one of the country's great visitor attractions has been named the Tree of the Year.