Classic two tier fountain water feature