Sir Elton John is to embark on a three-year farewell world tour as he bows out of live performing to spend more time with his children.