Stable Diffusion for Realistic Image Super-Resolution and Stylization