Deterministic Chaos in Malkus' Waterwheel: A simple dynamical system on the verge of low-dimensional chaotic behaviour