SNOW-650150: Add some indication to `DataFrame.show()` that it isn't all the results

What is the current behavior?

No indication that show is only printing top results, which could mislead users that aren't aware.

>>> df = session.range(1,12).to_df('col1') # create 11 element sequence
>>> df.show()
----------
|"COL1"  |
----------
|1       |
|2       |
|3       |
|4       |
|5       |
|6       |
|7       |
|8       |
|9       |
|10      |
----------
>>> df.show(n=11)
----------
|"COL1"  |
----------
|1       |
|2       |
|3       |
|4       |
|5       |
|6       |
|7       |
|8       |
|9       |
|10      |
|11      |
----------

What is the desired behavior?

Option 1:
Some indication that this is a paged result. Like 1/n, or 15 out of # rows (if that is efficient to do).

Option 2:
Create a DataFrame.head() function that replicates pandas behavior, making it more obvious that this is a preview.

How would this improve snowflake-snowpark-python?

Users will not accidentally realize that they are omitting results when results sets are right around the threshold of show

References, Other Background

Start by locating the DataFrame.show() entry point and its existing tests. Compare the two proposed behaviors—an indication that results are limited or a DataFrame.head() method—and confirm the intended direction before implementation. Done means users can clearly tell when show() omits rows, with coverage for the 11-row example.