A celebrity chauffeur murdered his wife and two children before turning the gun on himself in a gruesome Hollywood massacre, police say