Australia Day celebrations have been cancelled across parts of Queensland because of a severe weather system dumping torrential rain.