Star Trek and X-Men actor Sir Patrick Stewart has died after a "brief and poignant journey" with Alzheimer's and dementia.