Charles Manson, dubbed father of the world's worst family, has died aged 83 after spending the last four decades in prison.