An “eyesore” development site in South Shields which has sat unused for years could receive a new lease of life as apartments under new plans.