Oversight of South Wales Fire and Rescue Service is to be taken over by the Welsh Government, following a damning report into the organisation’s culture.