Former Hepworth Wakefield director appointed chief executive of London's Royal Academy The Art Newspaper