From B&Bs and backpacker hostels to luxury holiday home and live-aboard boat rentals, Pittwater accommodation offerings are boundless