A man has been arrested on suspicion of murder after a 40-year-old woman was shot dead in South Wales.