Horsham District Council has agreed to spend £488,000 converting the old ambulance station into a workshop for servicing food waste collection vehicles.