Paihia waterfront set for multi-million dollar facelift