Shy, intelligent, prone to a drink and generous to a fault. The people closest to the star remember a comedy legend hounded by the press and racked by depression