Sadly you can only play on your Vita through PS4 Link. Remote Play on the PS3 isn't supported (like, by any game ever as far as I'm aware).

It is remote play, so yes, you need a connection; you can connect directly to your PS4 if you're in wireless range, or over the internet if not. There is no offline mode.