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