A drug that destroys the characteristic protein plaques that build up in the brains of patients with Alzheimer’s is showing “tantalising” promise, scientists say.