A narrow majority of Americans now believe even moderate consumption of alcohol negatively affects health, as US drinking levels continue to decline, according to a recent survey.