Missing Great Yarmouth man was ‘very drunk’ before ending up in water at Corton