A sinkhole has opened up along the Hawkesbury River following devastating floodwaters, claiming a house in the process.