More affordable prices and stronger rental yields are drawing investors to cities like Manchester, Liverpool, and Newcastle.