Glasgow City Council has announced a £6.5m investment to combat the city's rampant rat problem, creating 200 jobs in the process.