A large sinkhole has appeared on a housing estate in South Wales, with the local council warning residents to stay away from the area.