Ideally, you want to clean your water feature every one or two months. Doing so will prevent the water from stagnating, which causes a stinky smell. You can also add filters and other safe chemicals, like vinegar, to prevent it from developing an odor. Moreover, remove any decaying matter, such as leaves, from the water fountain since it promotes bacteria growth.