Normal and stable approximation to subgraph counts in superpositions of Bernoulli random graphs