This riverside oasis is just minutes from Manhattan and epitomises Brooklyn-cool