You don't need a NOC as a letter. BUT your current sponsor will have to sign the transfer of sponsorship form, so you will obviously need his permission to transfer your sponsorship.
You don't need to cancel your visa or leave Qatar during your transfer of sponsorship process.