Emergency services launch major search operation as families are notified and public warned to stay out of water