People fishing with the pub manager heard him "yell, scream very loudly, followed by a large splashing of water", said Cairns police inspector Mark Henderson