A derelict Georgian mansion in Burley will be brought back into use as a care home after planning permission was granted.