The Mayor of West Yorkshire has said the Autumn budget presents “real challenges” for the county but is pleased with the backing for three key transport projects.