Aberdeenshire Council’s museums service has been found to be at “major risk” due to poor record keeping and numerous missing documents.