Painter best known for his work The Singing Butler was found dead at his apartment in Nice on Saturday