Sir Elton John vowed to never let his children be scared of him after his own childhood filled with "fear" and "walking on eggshells".