Kirklees Council has officially opened its new and modern gold standard day care facility for adults living with dementia.