Infinity pool and spa with cascading water feature