Appliances for preparing cold and carbonated water with installation under the counter