Former Manchester United footballer David May has shared his fears about developing dementia - and the impact that would have on his family.