Musician, who suffered from mental health problems, wrote and produced the 1966 album Pet Sounds – seen by many as the greatest album of all time