Shots were fired at a home in Rotherham and a man was rushed to hospital