'Ambitious' Ripon school praised by Ofsted for transformation