Plans for 46 new retirement homes in Northumberland have been granted approval despite fears over developer contributions.