Caerphilly county borough council’s education service has received a glowing report following a major inspection.