The man was found dead after going missing in floodwater north of Brisbane, as warnings were issued for the Lockyer Valley and Darling Downs.