Effective management crucial to prevent future water shortage: Official