Dozens of civilians have been killed in northern Syria after the Syrian regime targeted opposition-held areas with heavy air and ground bombardment.