An extra £300,000 will be used to fund specialist health visitors and extra support for families in need across Rotherham, Doncaster and South Humber.