Linda Nolan of the Nolan Sisters has died at the age of 65, just weeks after admitting how she deals with the fear of dying