Rare vintage photos from the private collection of Sir Elton John are to go on show in a special exhibition at Tate Modern.