Sir Elton John's husband David Furnish has revealed the iconic musician's "bitter-sweet decision" to retire from touring was made as a family.