Step 1: Understanding the Concept:
The critical position is the top of the circle. The water does not fall if at least the weight provides the centripetal force: \(mg \le m\omega^2r\).
Step 2: Minimum condition:
At the limiting case \(mg = m\omega^2r\), so \(\omega = \sqrt{\frac gr}\). The period is
\[ T = \frac{2\pi}{\omega} = 2\pi\sqrt{\frac rg} \]
Step 3: Meaning:
The period must be at most this value. Option (A) has g over r inside the root, which is the inverse of what we need, and (C) and (D) have wrong dimensions for a time.
Final Answer:
The required period is \(2\pi\sqrt{\frac rg}\), option (B).
\[ \boxed{2\pi\sqrt{\frac{r}{g}}} \]