Dense Gas and Star Formation: Characteristics of Cloud Cores Associated with Water Masers