National survey reveals that attitudes to people living with dementia are largely positive, with most people not seeing it as a stigmatising condition