Scottish immigrants found an ideal setting in Waipu; locals and holidaymakers feel the same way. Heather Whelan discovers more about this idyllic Northland town