A woman who went missing while water tubing near Brisbane on New Year's Eve has been found dead.